<!DOCTYPE html>
<html lang="en">
<head>
	<meta charset="UTF-8">
	<meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
	<title>MicroStrategy Desktop | ElasticSearch 7.7 权威指南中文版</title>
	<meta name="keywords" content="ElasticSearch 权威指南中文版, elasticsearch 7, es7, 实时数据分析，实时数据检索" />
    <meta name="description" content="ElasticSearch 权威指南中文版, elasticsearch 7, es7, 实时数据分析，实时数据检索" />
    <!-- Give IE8 a fighting chance -->
    <!--[if lt IE 9]>
    <script src="https://oss.maxcdn.com/html5shiv/3.7.2/html5shiv.min.js"></script>
    <script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
    <![endif]-->
	<link rel="stylesheet" type="text/css" href="../static/styles.css" />
	<script>
	var _link = 'sql-client-apps-microstrat.html';
    </script>
</head>
<body>
<div class="main-container">
    <section id="content">
        <div class="content-wrapper">
            <section id="guide" lang="zh_cn">
                <div class="container">
                    <div class="row">
                        <div class="col-xs-12 col-sm-8 col-md-8 guide-section">
                            <div style="color:gray; word-break: break-all; font-size:12px;">原英文版地址: <a href="https://www.elastic.co/guide/en/elasticsearch/reference/7.7/sql-client-apps-microstrat.html" rel="nofollow" target="_blank">https://www.elastic.co/guide/en/elasticsearch/reference/7.7/sql-client-apps-microstrat.html</a>, 原文档版权归 www.elastic.co 所有<br/>本地英文版地址: <a href="../en/sql-client-apps-microstrat.html" rel="nofollow" target="_blank">../en/sql-client-apps-microstrat.html</a></div>
                        <!-- start body -->
                  <div class="page_header">
<strong>重要</strong>: 此版本不会发布额外的bug修复或文档更新。最新信息请参考 <a href="https://www.elastic.co/guide/en/elasticsearch/reference/current/index.html" rel="nofollow">当前版本文档</a>。
</div>
<div id="content">
<div class="breadcrumbs">
<span class="breadcrumb-link"><a href="index.html">Elasticsearch Guide [7.7]</a></span>
»
<span class="breadcrumb-link"><a href="xpack-sql.html">SQL access</a></span>
»
<span class="breadcrumb-link"><a href="sql-client-apps.html">SQL Client Applications</a></span>
»
<span class="breadcrumb-node">MicroStrategy Desktop</span>
</div>
<div class="navheader">
<span class="prev">
<a href="sql-client-apps-ps1.html">« Microsoft PowerShell</a>
</span>
<span class="next">
<a href="sql-client-apps-qlik.html">Qlik Sense Desktop »</a>
</span>
</div>
<div class="section xpack">
<div class="titlepage"><div><div>
<h2 class="title">
<a id="sql-client-apps-microstrat"></a>MicroStrategy Desktop<a class="edit_me edit_me_private" rel="nofollow" title="Editing on GitHub is available to Elastic" href="https://github.com/elastic/elasticsearch/edit/7.7/docs/reference/sql/endpoints/client-apps/microstrat.asciidoc">edit</a><a class="xpack_tag" href="https://www.elastic.co/subscriptions"></a>
</h2>
</div></div></div>
<p>You can use the Elasticsearch ODBC driver to access Elasticsearch data from MicroStrategy Desktop.</p>
<div class="important admon">
<div class="icon"></div>
<div class="admon_content">
<p>Elastic does not endorse, promote or provide support for this application; for native Elasticsearch integration in this product, please reach out to its vendor.</p>
</div>
</div>
<div class="section">
<div class="titlepage"><div><div>
<h3 class="title">
<a id="_prerequisites_6"></a>Prerequisites<a class="edit_me edit_me_private" rel="nofollow" title="Editing on GitHub is available to Elastic" href="https://github.com/elastic/elasticsearch/edit/7.7/docs/reference/sql/endpoints/client-apps/microstrat.asciidoc">edit</a>
</h3>
</div></div></div>
<div class="ulist itemizedlist">
<ul class="itemizedlist">
<li class="listitem">
<a href="https://www.microstrategy.com/us/get-started/desktop" class="ulink" target="_top">MicroStrategy Desktop</a> 11 or higher
</li>
<li class="listitem">
Elasticsearch SQL <a class="xref" href="sql-odbc.html" title="SQL ODBC">ODBC driver</a>
</li>
<li class="listitem">
A preconfigured User or System DSN (see <a class="xref" href="sql-odbc-setup.html#dsn-configuration" title="2. Configure a DSN">Configuration</a> section on how to configure a DSN).
</li>
</ul>
</div>
</div>

<div class="section">
<div class="titlepage"><div><div>
<h3 class="title">
<a id="_data_loading_2"></a>Data loading<a class="edit_me edit_me_private" rel="nofollow" title="Editing on GitHub is available to Elastic" href="https://github.com/elastic/elasticsearch/edit/7.7/docs/reference/sql/endpoints/client-apps/microstrat.asciidoc">edit</a>
</h3>
</div></div></div>
<p>To use the Elasticsearch SQL ODBC Driver to load data into MicroStrategy Desktop perform the following steps in sequence.</p>
<div class="olist orderedlist">
<ol class="orderedlist">
<li class="listitem">
<p>Create a New Dossier</p>
<p>Once the application is launched, you’ll first need to create a <em>New Dossier</em>:</p>
<p><a id="apps_microstrat_newdossier"></a><span class="image"><img src="../static/images/sql/odbc/apps_microstrat_newdossier.png" alt="apps microstrat newdossier"></span></p>
</li>
<li class="listitem">
<p>New Data</p>
<p>To import into the <em>New Dossier</em> just opened, press on the <em>New Data</em> button in the <em>DATASETS</em> column:</p>
<p><a id="apps_microstrat_newdata"></a><span class="image"><img src="../static/images/sql/odbc/apps_microstrat_newdata.png" alt="apps microstrat newdata"></span></p>
</li>
<li class="listitem">
<p>Access data from Tables</p>
<p>This opens a new window that allows to choose the source to load data from. Click on the <em>Databases</em> icon:</p>
<p><a id="apps_microstrat_databases"></a><span class="image"><img src="../static/images/sql/odbc/apps_microstrat_databases.png" alt="apps microstrat databases"></span></p>
</li>
<li class="listitem">
<p>New Data Source</p>
<p>In the newly opened <em>Import from Table - Select</em> window, click on the <span class="strong strong"><strong>+</strong></span> button to the right of <em>DATA SOURCES</em> item:</p>
<p><a id="apps_microstrat_newds"></a><span class="image"><img src="../static/images/sql/odbc/apps_microstrat_newds.png" alt="apps microstrat newds"></span></p>
</li>
<li class="listitem">
<p>Data Source</p>
<p>In the <em>Data Source</em> window, tick the radio button for <em>DSN Data Sources</em>. In the <em>DSN</em> drop-down box, choose the name of the DSN that you
have previously configured. For the <em>Version</em>, chose <em>Generic DBMS</em>.</p>
<p>Input a user name and password in the provided fields.
Note that the application requires them irrespective of the fact that they might already be part of the previously configured DSN and the
new input will take precedence over those.</p>
<p>Finally, give a name to the application-specific data source you’re just configuring:</p>
<p><a id="apps_microstrat_dsn"></a><span class="image"><img src="../static/images/sql/odbc/apps_microstrat_dsn.png" alt="apps microstrat dsn"></span></p>
</li>
<li class="listitem">
<p>Select Import Options</p>
<p>Choosing an import methodology follows. You can pick any of the options; we’ll exemplify the <em>Select Tables</em> option:</p>
<p><a id="apps_microstrat_tables"></a><span class="image"><img src="../static/images/sql/odbc/apps_microstrat_tables.png" alt="apps microstrat tables"></span></p>
</li>
<li class="listitem">
<p>Import from Table - Select</p>
<p>The data source you’ve named two steps before is now listed in the <em>DATA SOURCES</em> column. Clicking on its name triggers the
application to query the Elasticsearch instance configured in the DSN and list the tables available within:</p>
<p><a id="apps_microstrat_loadtable"></a><span class="image"><img src="../static/images/sql/odbc/apps_microstrat_loadtable.png" alt="apps microstrat loadtable"></span></p>
</li>
<li class="listitem">
<p>Data Access Mode</p>
<p>Choose a table to load data from and press the <em>Finish</em> button. When doing so, the application offers to choose a loading methodology.
You can choose whichever, we’ll exemplify the <em>Connect Live</em> way:</p>
<p><a id="apps_microstrat_live"></a><span class="image"><img src="../static/images/sql/odbc/apps_microstrat_live.png" alt="apps microstrat live"></span></p>
</li>
<li class="listitem">
<p>Visualize the data</p>
<p>From the <em>DATASETS</em> column you can choose what table columns (or index fields) to visualize:</p>
<p><a id="apps_microstrat_visualize"></a><span class="image"><img src="../static/images/sql/odbc/apps_microstrat_visualize.png" alt="apps microstrat visualize"></span></p>
</li>
</ol>
</div>
</div>

</div>
<div class="navfooter">
<span class="prev">
<a href="sql-client-apps-ps1.html">« Microsoft PowerShell</a>
</span>
<span class="next">
<a href="sql-client-apps-qlik.html">Qlik Sense Desktop »</a>
</span>
</div>
</div>

                  <!-- end body -->
                        </div>
                        <div class="col-xs-12 col-sm-4 col-md-4" id="right_col">
                        
                        </div>
                    </div>
                </div>
            </section>
        </div>
    </section>
</div>
<script src="../static/cn.js"></script>
</body>
</html>